Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 7327407 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.5 GiB |
| Average record size in memory | 510.7 B |
Variable types
| DateTime | 4 |
|---|---|
| Numeric | 11 |
| Text | 5 |
| Categorical | 4 |
order_take_out_type_label is highly imbalanced (60.5%) | Imbalance |
bill_total_billed is highly skewed (γ1 = 169.5718289) | Skewed |
bill_total_discount_item_level is highly skewed (γ1 = 116.7694495) | Skewed |
bill_total_gratuity is highly skewed (γ1 = 501.5964988) | Skewed |
bill_total_net is highly skewed (γ1 = 157.400082) | Skewed |
bill_total_tax is highly skewed (γ1 = 305.4724136) | Skewed |
bill_total_voided is highly skewed (γ1 = 665.3228541) | Skewed |
payment_amount is highly skewed (γ1 = 1987.839703) | Skewed |
payment_total_tip is highly skewed (γ1 = 2683.250401) | Skewed |
sales_revenue_with_tax is highly skewed (γ1 = 169.5704025) | Skewed |
bill_uuid has unique values | Unique |
bill_total_billed has 192204 (2.6%) zeros | Zeros |
bill_total_discount_item_level has 6770774 (92.4%) zeros | Zeros |
bill_total_gratuity has 7157347 (97.7%) zeros | Zeros |
bill_total_net has 192460 (2.6%) zeros | Zeros |
bill_total_tax has 1056107 (14.4%) zeros | Zeros |
bill_total_voided has 7133326 (97.4%) zeros | Zeros |
payment_amount has 193161 (2.6%) zeros | Zeros |
payment_count has 179184 (2.4%) zeros | Zeros |
payment_total_tip has 4276747 (58.4%) zeros | Zeros |
sales_revenue_with_tax has 192212 (2.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-12 23:20:08.063792 |
|---|---|
| Analysis finished | 2025-02-12 23:36:24.390803 |
| Duration | 16 minutes and 16.33 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
| Distinct | 5112956 |
|---|---|
| Distinct (%) | 69.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| Minimum | 2024-07-01 00:00:01 |
|---|---|
| Maximum | 2025-01-01 21:41:43 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
bill_total_billed
Real number (ℝ)
Skewed  Zeros 
| Distinct | 48338 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.28303 |
| Minimum | -4712.1 |
|---|---|
| Maximum | 74928.61 |
| Zeros | 192204 |
| Zeros (%) | 2.6% |
| Negative | 12604 |
| Negative (%) | 0.2% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -4712.1 |
|---|---|
| 5-th percentile | 2.89 |
| Q1 | 10.32 |
| median | 22.01 |
| Q3 | 44.69 |
| 95-th percentile | 108.55 |
| Maximum | 74928.61 |
| Range | 79640.71 |
| Interquartile range (IQR) | 34.37 |
Descriptive statistics
| Standard deviation | 82.053465 |
|---|---|
| Coefficient of variation (CV) | 2.2614833 |
| Kurtosis | 107563.33 |
| Mean | 36.28303 |
| Median Absolute Deviation (MAD) | 14.46 |
| Skewness | 169.57183 |
| Sum | 2.6586053 × 108 |
| Variance | 6732.7711 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 192204 | 2.6% |
| 15.5 | 28759 | 0.4% |
| 7 | 26524 | 0.4% |
| 11.3 | 26045 | 0.4% |
| 6 | 24440 | 0.3% |
| 8 | 23779 | 0.3% |
| 18.9 | 22187 | 0.3% |
| 12 | 19656 | 0.3% |
| 4 | 19487 | 0.3% |
| 6.75 | 19254 | 0.3% |
| Other values (48328) | 6925072 |
| Value | Count | Frequency (%) |
| -4712.1 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2433.2 | 1 | |
| -1200 | 1 | |
| -1000 | 1 | |
| -773.39 | 1 | |
| -696.03 | 1 | |
| -651.41 | 1 | |
| -638.2 | 1 |
| Value | Count | Frequency (%) |
| 74928.61 | 1 | |
| 33928.25 | 1 | |
| 25131.48 | 1 | |
| 23132.39 | 1 | |
| 22088.31 | 1 | |
| 21000 | 1 | |
| 20551.26 | 1 | |
| 19866 | 1 | |
| 19021.08 | 1 | |
| 16589.81 | 1 |
bill_total_discount_item_level
Real number (ℝ)
Skewed  Zeros 
| Distinct | 18132 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.81173694 |
| Minimum | -74.3 |
|---|---|
| Maximum | 4763.45 |
| Zeros | 6770774 |
| Zeros (%) | 92.4% |
| Negative | 524 |
| Negative (%) | < 0.1% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -74.3 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.82 |
| Maximum | 4763.45 |
| Range | 4837.75 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 8.4987232 |
|---|---|
| Coefficient of variation (CV) | 10.4698 |
| Kurtosis | 37493.172 |
| Mean | 0.81173694 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 116.76945 |
| Sum | 5947926.9 |
| Variance | 72.228296 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6770774 | |
| 2 | 20086 | 0.3% |
| 1 | 18937 | 0.3% |
| 3 | 14649 | 0.2% |
| 5 | 13851 | 0.2% |
| 4 | 13299 | 0.2% |
| 6 | 10167 | 0.1% |
| 10 | 9229 | 0.1% |
| 8 | 7977 | 0.1% |
| 1.5 | 6834 | 0.1% |
| Other values (18122) | 441604 | 6.0% |
| Value | Count | Frequency (%) |
| -74.3 | 1 | |
| -66.25 | 1 | |
| -62.84 | 1 | |
| -59.06 | 2 | |
| -58.62 | 2 | |
| -55 | 1 | |
| -53.6 | 1 | |
| -53.26 | 1 | |
| -50.27 | 1 | |
| -44.04 | 1 |
| Value | Count | Frequency (%) |
| 4763.45 | 1 | |
| 4152 | 1 | |
| 3624.71 | 1 | |
| 2912.75 | 1 | |
| 2809 | 1 | |
| 2611 | 1 | |
| 2198 | 1 | |
| 2090 | 1 | |
| 2040 | 1 | |
| 1888.8 | 1 |
bill_total_gratuity
Real number (ℝ)
Skewed  Zeros 
| Distinct | 8038 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.24172149 |
| Minimum | -60 |
|---|---|
| Maximum | 11935.53 |
| Zeros | 7157347 |
| Zeros (%) | 97.7% |
| Negative | 24 |
| Negative (%) | < 0.1% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -60 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11935.53 |
| Range | 11995.53 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 8.722423 |
|---|---|
| Coefficient of variation (CV) | 36.084598 |
| Kurtosis | 539453.97 |
| Mean | 0.24172149 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 501.5965 |
| Sum | 1771191.8 |
| Variance | 76.080663 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7157347 | |
| 0.32 | 5362 | 0.1% |
| 0.15 | 4588 | 0.1% |
| 0.64 | 2047 | < 0.1% |
| 0.24 | 1775 | < 0.1% |
| 3.6 | 1367 | < 0.1% |
| 0.12 | 1274 | < 0.1% |
| 0.45 | 1256 | < 0.1% |
| 0.3 | 1253 | < 0.1% |
| 0.48 | 1102 | < 0.1% |
| Other values (8028) | 150036 | 2.0% |
| Value | Count | Frequency (%) |
| -60 | 1 | |
| -37.8 | 1 | |
| -19.08 | 1 | |
| -18.4 | 1 | |
| -12 | 1 | |
| -11.79 | 1 | |
| -9.58 | 1 | |
| -3.87 | 1 | |
| -2.74 | 1 | |
| -2.44 | 1 |
| Value | Count | Frequency (%) |
| 11935.53 | 1 | |
| 6005 | 1 | |
| 4029.21 | 1 | |
| 4003.25 | 1 | |
| 3402.7 | 1 | |
| 3245 | 1 | |
| 2916.32 | 1 | |
| 2504.6 | 1 | |
| 2492.6 | 1 | |
| 2469.19 | 1 |
bill_total_net
Real number (ℝ)
Skewed  Zeros 
| Distinct | 36640 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.46403 |
| Minimum | -4170 |
|---|---|
| Maximum | 66308.5 |
| Zeros | 192460 |
| Zeros (%) | 2.6% |
| Negative | 12449 |
| Negative (%) | 0.2% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -4170 |
|---|---|
| 5-th percentile | 2.75 |
| Q1 | 9.52 |
| median | 20.24 |
| Q3 | 41 |
| 95-th percentile | 100 |
| Maximum | 66308.5 |
| Range | 70478.5 |
| Interquartile range (IQR) | 31.48 |
Descriptive statistics
| Standard deviation | 76.127465 |
|---|---|
| Coefficient of variation (CV) | 2.2749043 |
| Kurtosis | 91094.796 |
| Mean | 33.46403 |
| Median Absolute Deviation (MAD) | 13.24 |
| Skewness | 157.40008 |
| Sum | 2.4520457 × 108 |
| Variance | 5795.3909 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 192460 | 2.6% |
| 8 | 65960 | 0.9% |
| 18 | 64383 | 0.9% |
| 10 | 58653 | 0.8% |
| 16 | 55866 | 0.8% |
| 5 | 55117 | 0.8% |
| 15 | 54506 | 0.7% |
| 12 | 53155 | 0.7% |
| 6 | 51607 | 0.7% |
| 20 | 46674 | 0.6% |
| Other values (36630) | 6629026 |
| Value | Count | Frequency (%) |
| -4170 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2342.09 | 1 | |
| -1200 | 1 | |
| -1000 | 1 | |
| -684.42 | 1 | |
| -647.5 | 1 | |
| -599 | 1 | |
| -596 | 1 |
| Value | Count | Frequency (%) |
| 66308.5 | 1 | |
| 30025 | 1 | |
| 22384.5 | 1 | |
| 22240.25 | 1 | |
| 20253.15 | 1 | |
| 20050 | 1 | |
| 19866 | 1 | |
| 18985 | 1 | |
| 17256 | 1 | |
| 15398.9 | 1 |
bill_total_tax
Real number (ℝ)
Skewed  Zeros 
| Distinct | 10043 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.819 |
| Minimum | -542.1 |
|---|---|
| Maximum | 8620.11 |
| Zeros | 1056107 |
| Zeros (%) | 14.4% |
| Negative | 9274 |
| Negative (%) | 0.1% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -542.1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.45 |
| median | 1.43 |
| Q3 | 3.49 |
| 95-th percentile | 9.75 |
| Maximum | 8620.11 |
| Range | 9162.21 |
| Interquartile range (IQR) | 3.04 |
Descriptive statistics
| Standard deviation | 7.1636406 |
|---|---|
| Coefficient of variation (CV) | 2.5411992 |
| Kurtosis | 306353.56 |
| Mean | 2.819 |
| Median Absolute Deviation (MAD) | 1.23 |
| Skewness | 305.47241 |
| Sum | 20655961 |
| Variance | 51.317747 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1056107 | 14.4% |
| 1.3 | 43081 | 0.6% |
| 0.9 | 39754 | 0.5% |
| 1.04 | 39536 | 0.5% |
| 0.52 | 39266 | 0.5% |
| 0.65 | 38705 | 0.5% |
| 0.24 | 37644 | 0.5% |
| 0.33 | 35709 | 0.5% |
| 2.08 | 35571 | 0.5% |
| 0.85 | 33725 | 0.5% |
| Other values (10033) | 5928309 |
| Value | Count | Frequency (%) |
| -542.1 | 1 | |
| -91.11 | 1 | |
| -88.97 | 1 | |
| -73.85 | 1 | |
| -73.42 | 1 | |
| -60.09 | 1 | |
| -58.71 | 1 | |
| -52.41 | 1 | |
| -51.39 | 1 | |
| -49.93 | 1 |
| Value | Count | Frequency (%) |
| 8620.11 | 1 | |
| 3903.25 | 1 | |
| 2891.23 | 1 | |
| 2038.31 | 1 | |
| 1765.08 | 1 | |
| 1566.26 | 1 | |
| 1505.53 | 1 | |
| 1334.81 | 1 | |
| 1300 | 1 | |
| 1242.85 | 1 |
bill_total_voided
Real number (ℝ)
Skewed  Zeros 
| Distinct | 9033 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.75326427 |
| Minimum | -4501.5 |
|---|---|
| Maximum | 43178.4 |
| Zeros | 7133326 |
| Zeros (%) | 97.4% |
| Negative | 510 |
| Negative (%) | < 0.1% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -4501.5 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 43178.4 |
| Range | 47679.9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 27.828199 |
|---|---|
| Coefficient of variation (CV) | 36.943474 |
| Kurtosis | 860737.37 |
| Mean | 0.75326427 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 665.32285 |
| Sum | 5519473.9 |
| Variance | 774.40866 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7133326 | |
| 8 | 4266 | 0.1% |
| 9 | 3669 | 0.1% |
| 10 | 3629 | < 0.1% |
| 16 | 3601 | < 0.1% |
| 6 | 3324 | < 0.1% |
| 12 | 3233 | < 0.1% |
| 5 | 3229 | < 0.1% |
| 15 | 2948 | < 0.1% |
| 7 | 2891 | < 0.1% |
| Other values (9023) | 163291 | 2.2% |
| Value | Count | Frequency (%) |
| -4501.5 | 1 | |
| -1697 | 1 | |
| -1665.9 | 1 | |
| -1215.15 | 1 | |
| -1173.15 | 1 | |
| -784.81 | 1 | |
| -538.55 | 1 | |
| -500 | 1 | |
| -380.75 | 1 | |
| -313.85 | 1 |
| Value | Count | Frequency (%) |
| 43178.4 | 1 | |
| 20835 | 1 | |
| 12766.5 | 1 | |
| 12749.46 | 1 | |
| 10176 | 1 | |
| 9440 | 1 | |
| 8216.42 | 1 | |
| 8000 | 1 | |
| 7312.62 | 1 | |
| 6800 | 1 |
bill_uuid
Text
Unique 
| Distinct | 7327407 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 455.0 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 49 |
| Mean length | 48.988761 |
| Min length | 36 |
Unique
| Unique | 7327407 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 240702200053~8792ADCC-545E-4AF3-9836-9C428ED8285C |
|---|---|
| 2nd row | 240703214339~B06B2A2F-B1A0-44C0-920A-242F41B58BD2 |
| 3rd row | 240703182356~D082FE98-841C-4EAB-B15E-BEA41FA1CDF0 |
| 4th row | 240703193321~273CBB07-FAB0-49B7-A445-8474F9A4570F |
| 5th row | 240705210114~D423B906-1AEE-4DB8-84BA-234267A14E05 |
| Value | Count | Frequency (%) |
| 240702200053~8792adcc-545e-4af3-9836-9c428ed8285c | 1 | < 0.1% |
| 240703214339~b06b2a2f-b1a0-44c0-920a-242f41b58bd2 | 1 | < 0.1% |
| 240703182356~d082fe98-841c-4eab-b15e-bea41fa1cdf0 | 1 | < 0.1% |
| 240703193321~273cbb07-fab0-49b7-a445-8474f9a4570f | 1 | < 0.1% |
| 240705210114~d423b906-1aee-4db8-84ba-234267a14e05 | 1 | < 0.1% |
| 240705210926~ca81a307-a782-42d4-b81d-250556cbe839 | 1 | < 0.1% |
| 240705202148~a47eec00-a5af-45ba-a892-171e7cdefe7c | 1 | < 0.1% |
| 240705182318~913c3f9f-e867-4e36-a3b1-e1e68fcbad16 | 1 | < 0.1% |
| 240706174632~1996e368-132e-43a2-9821-34bf48033ce1 | 1 | < 0.1% |
| 240706181722~a4851319-949c-4ff1-964d-c860684075b9 | 1 | < 0.1% |
| Other values (7327397) | 7327397 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 33548532 | 9.3% |
| 1 | 31557189 | 8.8% |
| 2 | 31504519 | 8.8% |
| - | 29309628 | 8.2% |
| 0 | 27344136 | 7.6% |
| 9 | 19845498 | 5.5% |
| 8 | 19837506 | 5.5% |
| 3 | 19610787 | 5.5% |
| 5 | 18804623 | 5.2% |
| 7 | 17803302 | 5.0% |
| Other values (14) | 109794868 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 358960588 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 33548532 | 9.3% |
| 1 | 31557189 | 8.8% |
| 2 | 31504519 | 8.8% |
| - | 29309628 | 8.2% |
| 0 | 27344136 | 7.6% |
| 9 | 19845498 | 5.5% |
| 8 | 19837506 | 5.5% |
| 3 | 19610787 | 5.5% |
| 5 | 18804623 | 5.2% |
| 7 | 17803302 | 5.0% |
| Other values (14) | 109794868 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 358960588 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 33548532 | 9.3% |
| 1 | 31557189 | 8.8% |
| 2 | 31504519 | 8.8% |
| - | 29309628 | 8.2% |
| 0 | 27344136 | 7.6% |
| 9 | 19845498 | 5.5% |
| 8 | 19837506 | 5.5% |
| 3 | 19610787 | 5.5% |
| 5 | 18804623 | 5.2% |
| 7 | 17803302 | 5.0% |
| Other values (14) | 109794868 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 358960588 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 33548532 | 9.3% |
| 1 | 31557189 | 8.8% |
| 2 | 31504519 | 8.8% |
| - | 29309628 | 8.2% |
| 0 | 27344136 | 7.6% |
| 9 | 19845498 | 5.5% |
| 8 | 19837506 | 5.5% |
| 3 | 19610787 | 5.5% |
| 5 | 18804623 | 5.2% |
| 7 | 17803302 | 5.0% |
| Other values (14) | 109794868 |
business_date
Date
| Distinct | 184 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| Minimum | 2024-07-01 00:00:00 |
|---|---|
| Maximum | 2024-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_duration_seconds
Real number (ℝ)
| Distinct | 65608 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2752.368 |
| Minimum | -44 |
|---|---|
| Maximum | 86397 |
| Zeros | 122 |
| Zeros (%) | < 0.1% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -44 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 106 |
| median | 1111 |
| Q3 | 3290 |
| 95-th percentile | 9088 |
| Maximum | 86397 |
| Range | 86441 |
| Interquartile range (IQR) | 3184 |
Descriptive statistics
| Standard deviation | 6207.1318 |
|---|---|
| Coefficient of variation (CV) | 2.2551969 |
| Kurtosis | 74.744784 |
| Mean | 2752.368 |
| Median Absolute Deviation (MAD) | 1060 |
| Skewness | 7.6162569 |
| Sum | 2.016772 × 1010 |
| Variance | 38528485 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42 | 26486 | 0.4% |
| 43 | 26436 | 0.4% |
| 46 | 26321 | 0.4% |
| 45 | 26242 | 0.4% |
| 40 | 26155 | 0.4% |
| 44 | 26104 | 0.4% |
| 47 | 25904 | 0.4% |
| 41 | 25902 | 0.4% |
| 38 | 25863 | 0.4% |
| 48 | 25762 | 0.4% |
| Other values (65598) | 7066232 |
| Value | Count | Frequency (%) |
| -44 | 1 | < 0.1% |
| -19 | 1 | < 0.1% |
| 0 | 122 | < 0.1% |
| 1 | 2155 | < 0.1% |
| 2 | 5486 | |
| 3 | 4312 | |
| 4 | 6022 | |
| 5 | 6382 | |
| 6 | 5637 | |
| 7 | 5224 |
| Value | Count | Frequency (%) |
| 86397 | 1 | |
| 86396 | 1 | |
| 86394 | 1 | |
| 86392 | 1 | |
| 86391 | 1 | |
| 86387 | 1 | |
| 86384 | 2 | |
| 86383 | 1 | |
| 86382 | 1 | |
| 86381 | 1 |
| Distinct | 4761314 |
|---|---|
| Distinct (%) | 65.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| Minimum | 2024-06-30 08:54:47 |
|---|---|
| Maximum | 2025-01-01 18:57:30 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 5083978 |
|---|---|
| Distinct (%) | 69.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| Minimum | 2024-07-01 00:00:01 |
|---|---|
| Maximum | 2025-01-01 21:41:43 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_take_out_type_label
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| dinein | |
|---|---|
| takeout | |
| onlineorder | 264578 |
| bartab | 180981 |
| delivery | 11786 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.3010723 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | dinein |
|---|---|
| 2nd row | dinein |
| 3rd row | dinein |
| 4th row | dinein |
| 5th row | dinein |
Common Values
| Value | Count | Frequency (%) |
| dinein | 6010445 | |
| takeout | 859617 | 11.7% |
| onlineorder | 264578 | 3.6% |
| bartab | 180981 | 2.5% |
| delivery | 11786 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dinein | 6010445 | |
| takeout | 859617 | 11.7% |
| onlineorder | 264578 | 3.6% |
| bartab | 180981 | 2.5% |
| delivery | 11786 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 12550046 | |
| i | 12297254 | |
| e | 7422790 | |
| d | 6286809 | |
| t | 1900215 | 4.1% |
| o | 1388773 | 3.0% |
| a | 1221579 | 2.6% |
| k | 859617 | 1.9% |
| u | 859617 | 1.9% |
| r | 721923 | 1.6% |
| Other values (4) | 661898 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 46170521 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 12550046 | |
| i | 12297254 | |
| e | 7422790 | |
| d | 6286809 | |
| t | 1900215 | 4.1% |
| o | 1388773 | 3.0% |
| a | 1221579 | 2.6% |
| k | 859617 | 1.9% |
| u | 859617 | 1.9% |
| r | 721923 | 1.6% |
| Other values (4) | 661898 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 46170521 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 12550046 | |
| i | 12297254 | |
| e | 7422790 | |
| d | 6286809 | |
| t | 1900215 | 4.1% |
| o | 1388773 | 3.0% |
| a | 1221579 | 2.6% |
| k | 859617 | 1.9% |
| u | 859617 | 1.9% |
| r | 721923 | 1.6% |
| Other values (4) | 661898 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 46170521 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 12550046 | |
| i | 12297254 | |
| e | 7422790 | |
| d | 6286809 | |
| t | 1900215 | 4.1% |
| o | 1388773 | 3.0% |
| a | 1221579 | 2.6% |
| k | 859617 | 1.9% |
| u | 859617 | 1.9% |
| r | 721923 | 1.6% |
| Other values (4) | 661898 | 1.4% |
order_uuid
Text
| Distinct | 6724735 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 455.0 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 49 |
| Mean length | 48.988761 |
| Min length | 36 |
Unique
| Unique | 6384062 ? |
|---|---|
| Unique (%) | 87.1% |
Sample
| 1st row | 240702183622~4B0A3D27-501D-4C94-BEBC-7B7F3C91A0F4 |
|---|---|
| 2nd row | 240703194731~40651D6D-4A16-4889-8C12-0F9A00D8BCF7 |
| 3rd row | 240703175025~0AEB61B0-220A-45A3-807E-78A1F432BB4C |
| 4th row | 240703180201~4B276496-BE92-4DE6-BD75-565929827014 |
| 5th row | 240705194141~F90FEB4F-D238-449E-B476-D16966DF4EEC |
| Value | Count | Frequency (%) |
| 240914174325~01482558-0947-4341-8662-cf4eb18cc045 | 52 | < 0.1% |
| 240913225853~632e2003-bd52-4c2d-a42d-cbe90c35535a | 43 | < 0.1% |
| 241018211013~83c159f1-9998-42ae-b8e2-06154a4a495f | 39 | < 0.1% |
| 240726211619~ce2ffa2c-3bb0-49f9-a695-f3bb0d074c73 | 38 | < 0.1% |
| 241012223955~38741a41-132a-4818-a003-c9dc425e4ed0 | 33 | < 0.1% |
| 241012194904~25c7b69f-c134-421a-ae23-927c922fa034 | 32 | < 0.1% |
| 241108234708~11accc10-5fbc-4559-84f0-73e7a8340afa | 31 | < 0.1% |
| 240920223808~092fe466-3c2a-46ef-8898-684dce87cd8b | 30 | < 0.1% |
| 241130223622~7e197c00-0901-4da1-baf9-b9376c261ef6 | 30 | < 0.1% |
| 241206233002~1066d6f0-1fd0-42c2-a919-be9e46763e88 | 30 | < 0.1% |
| Other values (6724725) | 7327049 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 33478345 | 9.3% |
| 1 | 32005804 | 8.9% |
| 2 | 31026448 | 8.6% |
| - | 29309628 | 8.2% |
| 0 | 27181486 | 7.6% |
| 8 | 19982388 | 5.6% |
| 9 | 19852290 | 5.5% |
| 3 | 19500073 | 5.4% |
| 5 | 18751295 | 5.2% |
| 7 | 17986919 | 5.0% |
| Other values (14) | 109885912 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 358960588 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 33478345 | 9.3% |
| 1 | 32005804 | 8.9% |
| 2 | 31026448 | 8.6% |
| - | 29309628 | 8.2% |
| 0 | 27181486 | 7.6% |
| 8 | 19982388 | 5.6% |
| 9 | 19852290 | 5.5% |
| 3 | 19500073 | 5.4% |
| 5 | 18751295 | 5.2% |
| 7 | 17986919 | 5.0% |
| Other values (14) | 109885912 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 358960588 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 33478345 | 9.3% |
| 1 | 32005804 | 8.9% |
| 2 | 31026448 | 8.6% |
| - | 29309628 | 8.2% |
| 0 | 27181486 | 7.6% |
| 8 | 19982388 | 5.6% |
| 9 | 19852290 | 5.5% |
| 3 | 19500073 | 5.4% |
| 5 | 18751295 | 5.2% |
| 7 | 17986919 | 5.0% |
| Other values (14) | 109885912 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 358960588 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 33478345 | 9.3% |
| 1 | 32005804 | 8.9% |
| 2 | 31026448 | 8.6% |
| - | 29309628 | 8.2% |
| 0 | 27181486 | 7.6% |
| 8 | 19982388 | 5.6% |
| 9 | 19852290 | 5.5% |
| 3 | 19500073 | 5.4% |
| 5 | 18751295 | 5.2% |
| 7 | 17986919 | 5.0% |
| Other values (14) | 109885912 |
payment_amount
Real number (ℝ)
Skewed  Zeros 
| Distinct | 55550 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.138697 |
| Minimum | -4712.1 |
|---|---|
| Maximum | 522752.27 |
| Zeros | 193161 |
| Zeros (%) | 2.6% |
| Negative | 12468 |
| Negative (%) | 0.2% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -4712.1 |
|---|---|
| 5-th percentile | 2.98 |
| Q1 | 10.92 |
| median | 23.65 |
| Q3 | 48.9 |
| 95-th percentile | 122.5 |
| Maximum | 522752.27 |
| Range | 527464.37 |
| Interquartile range (IQR) | 37.98 |
Descriptive statistics
| Standard deviation | 214.56711 |
|---|---|
| Coefficient of variation (CV) | 5.3456421 |
| Kurtosis | 4810881.6 |
| Mean | 40.138697 |
| Median Absolute Deviation (MAD) | 15.75 |
| Skewness | 1987.8397 |
| Sum | 2.9411257 × 108 |
| Variance | 46039.045 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 193161 | 2.6% |
| 15.5 | 25022 | 0.3% |
| 7 | 23095 | 0.3% |
| 6 | 22025 | 0.3% |
| 11.3 | 19907 | 0.3% |
| 5 | 18593 | 0.3% |
| 12 | 18589 | 0.3% |
| 8 | 18586 | 0.3% |
| 6.75 | 18427 | 0.3% |
| 3 | 18230 | 0.2% |
| Other values (55540) | 6951772 |
| Value | Count | Frequency (%) |
| -4712.1 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2433.2 | 1 | |
| -1200 | 1 | |
| -1000 | 1 | |
| -773.39 | 1 | |
| -696.03 | 1 | |
| -691.41 | 1 | |
| -638.2 | 1 |
| Value | Count | Frequency (%) |
| 522752.27 | 1 | |
| 86864.14 | 1 | |
| 39933.25 | 1 | |
| 29134.73 | 1 | |
| 27161.6 | 1 | |
| 25333.31 | 1 | |
| 25050.63 | 1 | |
| 24348.26 | 1 | |
| 23786.14 | 1 | |
| 22946 | 1 |
payment_count
Real number (ℝ)
Zeros 
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9837173 |
| Minimum | 0 |
|---|---|
| Maximum | 41 |
| Zeros | 179184 |
| Zeros (%) | 2.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 41 |
| Range | 41 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.19496385 |
|---|---|
| Coefficient of variation (CV) | 0.19819093 |
| Kurtosis | 610.22941 |
| Mean | 0.9837173 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.9853598 |
| Sum | 7208097 |
| Variance | 0.038010902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 7098389 | |
| 0 | 179184 | 2.4% |
| 2 | 43787 | 0.6% |
| 3 | 4124 | 0.1% |
| 4 | 1029 | < 0.1% |
| 5 | 470 | < 0.1% |
| 6 | 191 | < 0.1% |
| 7 | 96 | < 0.1% |
| 8 | 46 | < 0.1% |
| 9 | 28 | < 0.1% |
| Other values (15) | 63 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 179184 | 2.4% |
| 1 | 7098389 | |
| 2 | 43787 | 0.6% |
| 3 | 4124 | 0.1% |
| 4 | 1029 | < 0.1% |
| 5 | 470 | < 0.1% |
| 6 | 191 | < 0.1% |
| 7 | 96 | < 0.1% |
| 8 | 46 | < 0.1% |
| 9 | 28 | < 0.1% |
| Value | Count | Frequency (%) |
| 41 | 1 | < 0.1% |
| 29 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 2 | |
| 20 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 18 | 2 | |
| 17 | 2 | |
| 16 | 3 |
payment_total_tip
Real number (ℝ)
Skewed  Zeros 
| Distinct | 11413 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6178704 |
| Minimum | -253.14 |
|---|---|
| Maximum | 522715.64 |
| Zeros | 4276747 |
| Zeros (%) | 58.4% |
| Negative | 100 |
| Negative (%) | < 0.1% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -253.14 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.2 |
| 95-th percentile | 16.41 |
| Maximum | 522715.64 |
| Range | 522968.78 |
| Interquartile range (IQR) | 4.2 |
Descriptive statistics
| Standard deviation | 193.67719 |
|---|---|
| Coefficient of variation (CV) | 53.533478 |
| Kurtosis | 7240831.5 |
| Mean | 3.6178704 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2683.2504 |
| Sum | 26509609 |
| Variance | 37510.852 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4276747 | |
| 5 | 145569 | 2.0% |
| 2 | 122759 | 1.7% |
| 10 | 116203 | 1.6% |
| 1 | 107670 | 1.5% |
| 3 | 83271 | 1.1% |
| 4 | 57886 | 0.8% |
| 20 | 49432 | 0.7% |
| 6 | 47655 | 0.7% |
| 8 | 41089 | 0.6% |
| Other values (11403) | 2279126 |
| Value | Count | Frequency (%) |
| -253.14 | 1 | |
| -207.36 | 1 | |
| -198.42 | 1 | |
| -189.5 | 1 | |
| -179.9 | 1 | |
| -129.8 | 1 | |
| -101.7 | 1 | |
| -99 | 1 | |
| -83.88 | 1 | |
| -79.7 | 1 |
| Value | Count | Frequency (%) |
| 522715.64 | 1 | |
| 23762.38 | 1 | |
| 17668.02 | 1 | |
| 5180.16 | 1 | |
| 4050.63 | 1 | |
| 3797 | 1 | |
| 3080 | 1 | |
| 2714.25 | 1 | |
| 2635.09 | 1 | |
| 2338.94 | 1 |
sales_revenue_with_tax
Real number (ℝ)
Skewed  Zeros 
| Distinct | 48336 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.283892 |
| Minimum | -4712.1 |
|---|---|
| Maximum | 74928.61 |
| Zeros | 192212 |
| Zeros (%) | 2.6% |
| Negative | 12603 |
| Negative (%) | 0.2% |
| Memory size | 111.8 MiB |
Quantile statistics
| Minimum | -4712.1 |
|---|---|
| 5-th percentile | 2.89 |
| Q1 | 10.32 |
| median | 22.01 |
| Q3 | 44.7 |
| 95-th percentile | 108.56 |
| Maximum | 74928.61 |
| Range | 79640.71 |
| Interquartile range (IQR) | 34.38 |
Descriptive statistics
| Standard deviation | 82.053691 |
|---|---|
| Coefficient of variation (CV) | 2.2614357 |
| Kurtosis | 107562.13 |
| Mean | 36.283892 |
| Median Absolute Deviation (MAD) | 14.46 |
| Skewness | 169.5704 |
| Sum | 2.6586685 × 108 |
| Variance | 6732.8082 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 192212 | 2.6% |
| 15.5 | 28759 | 0.4% |
| 7 | 26524 | 0.4% |
| 11.3 | 26045 | 0.4% |
| 6 | 24440 | 0.3% |
| 8 | 23779 | 0.3% |
| 18.9 | 22187 | 0.3% |
| 12 | 19656 | 0.3% |
| 4 | 19559 | 0.3% |
| 6.75 | 19254 | 0.3% |
| Other values (48326) | 6924992 |
| Value | Count | Frequency (%) |
| -4712.1 | 1 | |
| -3323.28 | 1 | |
| -2625 | 1 | |
| -2433.2 | 1 | |
| -1200 | 1 | |
| -1000 | 1 | |
| -773.39 | 1 | |
| -696.03 | 1 | |
| -651.41 | 1 | |
| -638.2 | 1 |
| Value | Count | Frequency (%) |
| 74928.61 | 1 | |
| 33928.25 | 1 | |
| 25131.48 | 1 | |
| 23132.39 | 1 | |
| 22088.31 | 1 | |
| 21000 | 1 | |
| 20551.26 | 1 | |
| 19866 | 1 | |
| 19021.08 | 1 | |
| 16589.81 | 1 |
venue_xref_id
Text
| Distinct | 465 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 559.9 MiB |
Length
| Max length | 64 |
|---|---|
| Median length | 64 |
| Mean length | 64 |
| Min length | 64 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 |
|---|---|
| 2nd row | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 |
| 3rd row | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 |
| 4th row | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 |
| 5th row | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 |
| Value | Count | Frequency (%) |
| 5e8a21ead84851c212c2cae58849de4d37bc0babfcab05ceff51350412eb3e94 | 85962 | 1.2% |
| 6c4ddbba39d1529689be33c4769223b1194ba2dcb9e20f266d18face3279d00a | 79705 | 1.1% |
| 1fba23fbdd499646399a75417304d971f5fdea72bce5ba4b0d9e6086ac093892 | 74945 | 1.0% |
| 68e559beb80a2ae3cbdbf07043ebf35fbbccd85494216a2f32b31da76ece5ac0 | 73329 | 1.0% |
| 5dc459c71f4739c3dbd5872b4d442295864cf5715f704b19e02e1a581453561a | 72665 | 1.0% |
| 92128c7fc22f3f685e9914450a0bd855e258aafff9351663260b080a4a7c5188 | 68486 | 0.9% |
| 6afc5202235f3b742e6482c94536ab8462f6022054eccb0c6d5630c211c0a7fe | 66103 | 0.9% |
| 5ece4507d7aec26fdcca66082fcc77457f79cea602c1a82122c7ea496d37c493 | 65298 | 0.9% |
| 3c5a0e6460177d012e070306ba429335066823de1e25aa1ffbd3df7966cacd81 | 64713 | 0.9% |
| 7cd024c525a7952ce599081035cf063cb3b0c52626072b2014a79055ef37d670 | 63627 | 0.9% |
| Other values (455) | 6612574 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 32191833 | 6.9% |
| e | 31070515 | 6.6% |
| c | 30968596 | 6.6% |
| 0 | 29920795 | 6.4% |
| f | 29749227 | 6.3% |
| b | 29595969 | 6.3% |
| a | 29270116 | 6.2% |
| 3 | 29241722 | 6.2% |
| 6 | 29107403 | 6.2% |
| d | 28884875 | 6.2% |
| Other values (6) | 168952997 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 468954048 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 32191833 | 6.9% |
| e | 31070515 | 6.6% |
| c | 30968596 | 6.6% |
| 0 | 29920795 | 6.4% |
| f | 29749227 | 6.3% |
| b | 29595969 | 6.3% |
| a | 29270116 | 6.2% |
| 3 | 29241722 | 6.2% |
| 6 | 29107403 | 6.2% |
| d | 28884875 | 6.2% |
| Other values (6) | 168952997 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 468954048 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 32191833 | 6.9% |
| e | 31070515 | 6.6% |
| c | 30968596 | 6.6% |
| 0 | 29920795 | 6.4% |
| f | 29749227 | 6.3% |
| b | 29595969 | 6.3% |
| a | 29270116 | 6.2% |
| 3 | 29241722 | 6.2% |
| 6 | 29107403 | 6.2% |
| d | 28884875 | 6.2% |
| Other values (6) | 168952997 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 468954048 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 32191833 | 6.9% |
| e | 31070515 | 6.6% |
| c | 30968596 | 6.6% |
| 0 | 29920795 | 6.4% |
| f | 29749227 | 6.3% |
| b | 29595969 | 6.3% |
| a | 29270116 | 6.2% |
| 3 | 29241722 | 6.2% |
| 6 | 29107403 | 6.2% |
| d | 28884875 | 6.2% |
| Other values (6) | 168952997 |
waiter_uuid
Text
| Distinct | 7478 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 441.2 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 49 |
| Mean length | 47.017436 |
| Min length | 20 |
Unique
| Unique | 255 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 200421150750~37D0C51E-EC4F-4EA1-B549-D223DA183ABD |
|---|---|
| 2nd row | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA |
| 3rd row | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA |
| 4th row | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA |
| 5th row | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA |
| Value | Count | Frequency (%) |
| 190405092446~8646fe39-600c-4318-bea7-0a31d4082914 | 384686 | 5.2% |
| 200122200826~9afddbd1-59a4-4016-ad66-830100e21632 | 43219 | 0.6% |
| 220808130537~4ff8785d-4a7b-49ff-a7fe-b8551b6591d0 | 38719 | 0.5% |
| 150101000000~99c97c5b-82ae-48b5-a578-cc528ee0c57c | 37387 | 0.5% |
| cc66dfde-4181-46f5-a04d-d14424650700 | 37364 | 0.5% |
| 201209123916~356b9122-4031-4a51-886f-8dcea9d8afc5 | 36166 | 0.5% |
| 220528101742~8c27e6e6-4320-45ad-aea9-fdb28a8364cd | 31502 | 0.4% |
| 160111173131~2be06004-30a3-4159-8213-0d8ece0549c4 | 27662 | 0.4% |
| 191105151117~57504afc-9510-479d-bb67-82e999f616c2 | 26426 | 0.4% |
| 230725153957~09eb7f75-4154-4ec6-83d7-c24ea0ca08ab | 24989 | 0.3% |
| Other values (7468) | 6639287 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 29416383 | 8.5% |
| - | 29309596 | 8.5% |
| 0 | 28913626 | 8.4% |
| 1 | 28490199 | 8.3% |
| 2 | 27342752 | 7.9% |
| 3 | 19948474 | 5.8% |
| 9 | 19157625 | 5.6% |
| 5 | 18667807 | 5.4% |
| 8 | 18658318 | 5.4% |
| 6 | 17348296 | 5.0% |
| Other values (23) | 107262811 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 344515887 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 29416383 | 8.5% |
| - | 29309596 | 8.5% |
| 0 | 28913626 | 8.4% |
| 1 | 28490199 | 8.3% |
| 2 | 27342752 | 7.9% |
| 3 | 19948474 | 5.8% |
| 9 | 19157625 | 5.6% |
| 5 | 18667807 | 5.4% |
| 8 | 18658318 | 5.4% |
| 6 | 17348296 | 5.0% |
| Other values (23) | 107262811 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 344515887 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 29416383 | 8.5% |
| - | 29309596 | 8.5% |
| 0 | 28913626 | 8.4% |
| 1 | 28490199 | 8.3% |
| 2 | 27342752 | 7.9% |
| 3 | 19948474 | 5.8% |
| 9 | 19157625 | 5.6% |
| 5 | 18667807 | 5.4% |
| 8 | 18658318 | 5.4% |
| 6 | 17348296 | 5.0% |
| Other values (23) | 107262811 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 344515887 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 29416383 | 8.5% |
| - | 29309596 | 8.5% |
| 0 | 28913626 | 8.4% |
| 1 | 28490199 | 8.3% |
| 2 | 27342752 | 7.9% |
| 3 | 19948474 | 5.8% |
| 9 | 19157625 | 5.6% |
| 5 | 18667807 | 5.4% |
| 8 | 18658318 | 5.4% |
| 6 | 17348296 | 5.0% |
| Other values (23) | 107262811 |
concept
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| FAMILY_DINING | |
|---|---|
| CAFE | |
| BAR | |
| FAST_CASUAL | |
| BAKERY | |
| Other values (9) |
Length
| Max length | 21 |
|---|---|
| Median length | 13 |
| Mean length | 8.5454175 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BAR |
|---|---|
| 2nd row | BAR |
| 3rd row | BAR |
| 4th row | BAR |
| 5th row | BAR |
Common Values
| Value | Count | Frequency (%) |
| FAMILY_DINING | 2531818 | |
| CAFE | 1445320 | |
| BAR | 1248070 | |
| FAST_CASUAL | 933396 | 12.7% |
| BAKERY | 305322 | 4.2% |
| BREWERY | 280258 | 3.8% |
| FINE_DINING | 247651 | 3.4% |
| FAST_FOOD | 191842 | 2.6% |
| HOTEL | 52400 | 0.7% |
| ENTERTAINMENT_COMPLEX | 51919 | 0.7% |
| Other values (4) | 39411 | 0.5% |
Length
| Value | Count | Frequency (%) |
| family_dining | 2531818 | |
| cafe | 1445320 | |
| bar | 1248070 | |
| fast_casual | 933396 | 12.7% |
| bakery | 305322 | 4.2% |
| brewery | 280258 | 3.8% |
| fine_dining | 247651 | 3.4% |
| fast_food | 191842 | 2.6% |
| hotel | 52400 | 0.7% |
| entertainment_complex | 51919 | 0.7% |
| Other values (4) | 39411 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 8574479 | |
| I | 8390326 | |
| N | 5962346 | |
| F | 5600247 | 8.9% |
| _ | 3976343 | 6.4% |
| L | 3569547 | 5.7% |
| Y | 3117398 | 5.0% |
| D | 2990301 | 4.8% |
| E | 2838579 | 4.5% |
| G | 2779469 | 4.4% |
| Other values (13) | 14816717 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 62615752 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 8574479 | |
| I | 8390326 | |
| N | 5962346 | |
| F | 5600247 | 8.9% |
| _ | 3976343 | 6.4% |
| L | 3569547 | 5.7% |
| Y | 3117398 | 5.0% |
| D | 2990301 | 4.8% |
| E | 2838579 | 4.5% |
| G | 2779469 | 4.4% |
| Other values (13) | 14816717 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 62615752 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 8574479 | |
| I | 8390326 | |
| N | 5962346 | |
| F | 5600247 | 8.9% |
| _ | 3976343 | 6.4% |
| L | 3569547 | 5.7% |
| Y | 3117398 | 5.0% |
| D | 2990301 | 4.8% |
| E | 2838579 | 4.5% |
| G | 2779469 | 4.4% |
| Other values (13) | 14816717 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 62615752 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 8574479 | |
| I | 8390326 | |
| N | 5962346 | |
| F | 5600247 | 8.9% |
| _ | 3976343 | 6.4% |
| L | 3569547 | 5.7% |
| Y | 3117398 | 5.0% |
| D | 2990301 | 4.8% |
| E | 2838579 | 4.5% |
| G | 2779469 | 4.4% |
| Other values (13) | 14816717 |
city
Text
| Distinct | 295 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 170.0 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 20 |
| Mean length | 8.2089334 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Grand Forks |
|---|---|
| 2nd row | Grand Forks |
| 3rd row | Grand Forks |
| 4th row | Grand Forks |
| 5th row | Grand Forks |
| Value | Count | Frequency (%) |
| toronto | 1001138 | 12.0% |
| vancouver | 602167 | 7.2% |
| ottawa | 283547 | 3.4% |
| calgary | 256330 | 3.1% |
| houston | 189250 | 2.3% |
| edmonton | 154532 | 1.8% |
| banff | 137289 | 1.6% |
| mississauga | 129973 | 1.6% |
| york | 125956 | 1.5% |
| denver | 121743 | 1.5% |
| Other values (316) | 5372203 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 7565385 | 12.6% |
| a | 5260106 | 8.7% |
| n | 5003485 | 8.3% |
| r | 4574222 | 7.6% |
| t | 4010475 | 6.7% |
| e | 3960850 | 6.6% |
| i | 2872052 | 4.8% |
| l | 2247121 | 3.7% |
| s | 2115147 | 3.5% |
| u | 1711412 | 2.8% |
| Other values (44) | 20829941 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60150196 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 7565385 | 12.6% |
| a | 5260106 | 8.7% |
| n | 5003485 | 8.3% |
| r | 4574222 | 7.6% |
| t | 4010475 | 6.7% |
| e | 3960850 | 6.6% |
| i | 2872052 | 4.8% |
| l | 2247121 | 3.7% |
| s | 2115147 | 3.5% |
| u | 1711412 | 2.8% |
| Other values (44) | 20829941 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60150196 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 7565385 | 12.6% |
| a | 5260106 | 8.7% |
| n | 5003485 | 8.3% |
| r | 4574222 | 7.6% |
| t | 4010475 | 6.7% |
| e | 3960850 | 6.6% |
| i | 2872052 | 4.8% |
| l | 2247121 | 3.7% |
| s | 2115147 | 3.5% |
| u | 1711412 | 2.8% |
| Other values (44) | 20829941 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60150196 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 7565385 | 12.6% |
| a | 5260106 | 8.7% |
| n | 5003485 | 8.3% |
| r | 4574222 | 7.6% |
| t | 4010475 | 6.7% |
| e | 3960850 | 6.6% |
| i | 2872052 | 4.8% |
| l | 2247121 | 3.7% |
| s | 2115147 | 3.5% |
| u | 1711412 | 2.8% |
| Other values (44) | 20829941 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| CA | 4589801 | |
| US | 2737606 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ca | 4589801 | |
| us | 2737606 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 4589801 | |
| A | 4589801 | |
| U | 2737606 | |
| S | 2737606 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14654814 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 4589801 | |
| A | 4589801 | |
| U | 2737606 | |
| S | 2737606 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14654814 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 4589801 | |
| A | 4589801 | |
| U | 2737606 | |
| S | 2737606 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14654814 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 4589801 | |
| A | 4589801 | |
| U | 2737606 | |
| S | 2737606 |
start_of_day_offset
Categorical
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.8 MiB |
| 00:00:00 | |
|---|---|
| 05:00:00 | |
| 04:00:00 | |
| 06:00:00 | |
| 07:00:00 | 331455 |
| Other values (13) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 03:00:00 |
|---|---|
| 2nd row | 03:00:00 |
| 3rd row | 03:00:00 |
| 4th row | 03:00:00 |
| 5th row | 03:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 00:00:00 | 4249611 | |
| 05:00:00 | 692339 | 9.4% |
| 04:00:00 | 615708 | 8.4% |
| 06:00:00 | 453733 | 6.2% |
| 07:00:00 | 331455 | 4.5% |
| 08:00:00 | 198770 | 2.7% |
| 03:00:00 | 187945 | 2.6% |
| 09:00:00 | 144448 | 2.0% |
| 02:00:00 | 116913 | 1.6% |
| 10:00:00 | 112852 | 1.5% |
| Other values (8) | 223633 | 3.1% |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 4249611 | |
| 05:00:00 | 692339 | 9.4% |
| 04:00:00 | 615708 | 8.4% |
| 06:00:00 | 453733 | 6.2% |
| 07:00:00 | 331455 | 4.5% |
| 08:00:00 | 198770 | 2.7% |
| 03:00:00 | 187945 | 2.6% |
| 09:00:00 | 144448 | 2.0% |
| 02:00:00 | 116913 | 1.6% |
| 10:00:00 | 112852 | 1.5% |
| Other values (8) | 223633 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 40737456 | |
| : | 14654814 | 25.0% |
| 5 | 711378 | 1.2% |
| 4 | 622421 | 1.1% |
| 6 | 460300 | 0.8% |
| 1 | 369787 | 0.6% |
| 7 | 351719 | 0.6% |
| 3 | 200880 | 0.3% |
| 8 | 198770 | 0.3% |
| 2 | 167283 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 58619256 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 40737456 | |
| : | 14654814 | 25.0% |
| 5 | 711378 | 1.2% |
| 4 | 622421 | 1.1% |
| 6 | 460300 | 0.8% |
| 1 | 369787 | 0.6% |
| 7 | 351719 | 0.6% |
| 3 | 200880 | 0.3% |
| 8 | 198770 | 0.3% |
| 2 | 167283 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 58619256 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 40737456 | |
| : | 14654814 | 25.0% |
| 5 | 711378 | 1.2% |
| 4 | 622421 | 1.1% |
| 6 | 460300 | 0.8% |
| 1 | 369787 | 0.6% |
| 7 | 351719 | 0.6% |
| 3 | 200880 | 0.3% |
| 8 | 198770 | 0.3% |
| 2 | 167283 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 58619256 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 40737456 | |
| : | 14654814 | 25.0% |
| 5 | 711378 | 1.2% |
| 4 | 622421 | 1.1% |
| 6 | 460300 | 0.8% |
| 1 | 369787 | 0.6% |
| 7 | 351719 | 0.6% |
| 3 | 200880 | 0.3% |
| 8 | 198770 | 0.3% |
| 2 | 167283 | 0.3% |
Interactions
Missing values
Sample
| bill_paid_at_local | bill_total_billed | bill_total_discount_item_level | bill_total_gratuity | bill_total_net | bill_total_tax | bill_total_voided | bill_uuid | business_date | order_duration_seconds | order_seated_at_local | order_closed_at_local | order_take_out_type_label | order_uuid | payment_amount | payment_count | payment_total_tip | sales_revenue_with_tax | venue_xref_id | waiter_uuid | concept | city | country | start_of_day_offset | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7943 | 2024-07-02 20:00:53 | 102.53 | 0.0 | 0.0 | 95.0 | 7.53 | 0.0 | 240702200053~8792ADCC-545E-4AF3-9836-9C428ED8285C | 2024-07-02 | 5071 | 2024-07-02 18:36:22 | 2024-07-02 20:00:53 | dinein | 240702183622~4B0A3D27-501D-4C94-BEBC-7B7F3C91A0F4 | 124.53 | 1 | 22.00 | 102.53 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 200421150750~37D0C51E-EC4F-4EA1-B549-D223DA183ABD | BAR | Grand Forks | US | 03:00:00 |
| 7944 | 2024-07-03 21:43:39 | 5.38 | 5.0 | 0.0 | 5.0 | 0.38 | 0.0 | 240703214339~B06B2A2F-B1A0-44C0-920A-242F41B58BD2 | 2024-07-03 | 6968 | 2024-07-03 19:47:31 | 2024-07-03 21:43:39 | dinein | 240703194731~40651D6D-4A16-4889-8C12-0F9A00D8BCF7 | 5.38 | 1 | 0.00 | 5.38 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7945 | 2024-07-03 18:23:56 | 141.90 | 0.0 | 0.0 | 132.0 | 9.90 | 0.0 | 240703182356~D082FE98-841C-4EAB-B15E-BEA41FA1CDF0 | 2024-07-03 | 2011 | 2024-07-03 17:50:25 | 2024-07-03 18:23:56 | dinein | 240703175025~0AEB61B0-220A-45A3-807E-78A1F432BB4C | 171.90 | 1 | 30.00 | 141.90 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7946 | 2024-07-03 19:33:21 | 63.77 | 0.0 | 0.0 | 59.0 | 4.77 | 0.0 | 240703193321~273CBB07-FAB0-49B7-A445-8474F9A4570F | 2024-07-03 | 5480 | 2024-07-03 18:02:01 | 2024-07-03 19:33:21 | dinein | 240703180201~4B276496-BE92-4DE6-BD75-565929827014 | 73.77 | 1 | 10.00 | 63.77 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7947 | 2024-07-05 21:01:14 | 210.65 | 0.0 | 0.0 | 195.0 | 15.65 | 0.0 | 240705210114~D423B906-1AEE-4DB8-84BA-234267A14E05 | 2024-07-05 | 4773 | 2024-07-05 19:41:41 | 2024-07-05 21:01:14 | dinein | 240705194141~F90FEB4F-D238-449E-B476-D16966DF4EEC | 252.65 | 1 | 42.00 | 210.65 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7948 | 2024-07-05 21:09:26 | 50.93 | 0.0 | 0.0 | 47.0 | 3.93 | 0.0 | 240705210926~CA81A307-A782-42D4-B81D-250556CBE839 | 2024-07-05 | 4820 | 2024-07-05 19:49:06 | 2024-07-05 21:09:26 | dinein | 240705194906~A090563D-5272-4F52-AD09-9316178D53F5 | 60.93 | 1 | 10.00 | 50.93 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7949 | 2024-07-05 20:21:48 | 157.94 | 0.0 | 0.0 | 146.0 | 11.94 | 0.0 | 240705202148~A47EEC00-A5AF-45BA-A892-171E7CDEFE7C | 2024-07-05 | 5555 | 2024-07-05 18:49:13 | 2024-07-05 20:21:48 | dinein | 240705184913~CEE4782F-A70E-4F8F-8912-BCFC97B5AD35 | 187.94 | 1 | 30.00 | 157.94 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7950 | 2024-07-05 18:23:18 | 151.58 | 0.0 | 0.0 | 141.0 | 10.58 | 0.0 | 240705182318~913C3F9F-E867-4E36-A3B1-E1E68FCBAD16 | 2024-07-05 | 4263 | 2024-07-05 17:12:15 | 2024-07-05 18:23:18 | dinein | 240705171215~0EE5ACBB-3F73-4E16-A806-FF4084E46F5F | 181.58 | 1 | 30.00 | 151.58 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7951 | 2024-07-06 17:46:32 | 79.55 | 0.0 | 0.0 | 74.0 | 5.55 | 0.0 | 240706174632~1996E368-132E-43A2-9821-34BF48033CE1 | 2024-07-06 | 1904 | 2024-07-06 17:14:48 | 2024-07-06 17:46:32 | dinein | 240706171448~3E583E38-3B31-45E7-A0BE-57C18EA214A7 | 79.55 | 1 | 0.00 | 79.55 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA | BAR | Grand Forks | US | 03:00:00 |
| 7952 | 2024-07-06 18:17:22 | 56.64 | 0.0 | 0.0 | 52.5 | 4.14 | 0.0 | 240706181722~A4851319-949C-4FF1-964D-C860684075B9 | 2024-07-06 | 2077 | 2024-07-06 17:42:45 | 2024-07-06 18:17:22 | dinein | 240706174245~80595C36-1C6B-4842-88D1-B5BD7E063DE8 | 68.00 | 1 | 11.36 | 56.64 | 885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288 | 230816152907~E53E7ACE-FD5E-4E0B-B059-25E513F576B2 | BAR | Grand Forks | US | 03:00:00 |
| bill_paid_at_local | bill_total_billed | bill_total_discount_item_level | bill_total_gratuity | bill_total_net | bill_total_tax | bill_total_voided | bill_uuid | business_date | order_duration_seconds | order_seated_at_local | order_closed_at_local | order_take_out_type_label | order_uuid | payment_amount | payment_count | payment_total_tip | sales_revenue_with_tax | venue_xref_id | waiter_uuid | concept | city | country | start_of_day_offset | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167154 | 2024-12-27 17:40:58 | 24.98 | 0.00 | 0.0 | 24.98 | 0.0 | 0.0 | 241227174057~0A0B75D8-71B8-4625-80D8-91924BA9E18E | 2024-12-27 | 507 | 2024-12-27 17:32:31 | 2024-12-27 17:40:58 | takeout | 241227173231~6B94AD74-4C11-4977-8A1D-2CD15C39AB36 | 24.98 | 1 | 0.0 | 24.98 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 221116163611~F844A24E-44E8-40F2-B6D0-073FF805DBF7 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167155 | 2024-12-27 17:54:19 | 78.43 | 0.00 | 0.0 | 78.43 | 0.0 | 0.0 | 241227175419~FDCA9A8B-8515-47A8-B438-E95FE1B7177B | 2024-12-27 | 3853 | 2024-12-27 16:50:06 | 2024-12-27 17:54:19 | dinein | 241227165006~8559E840-33DD-47EA-844E-211E68ED17A3 | 78.43 | 1 | 0.0 | 78.43 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230202164435~D6FB6D1F-F2E2-4DB2-8278-59AAFF09A7F4 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167156 | 2024-12-27 21:32:43 | 108.90 | 0.00 | 0.0 | 108.90 | 0.0 | 0.0 | 241227213243~3465F212-5737-4B4A-9FE4-B528E630C08D | 2024-12-27 | 3859 | 2024-12-27 20:28:24 | 2024-12-27 21:32:43 | dinein | 241227202824~BB60AF10-4446-4659-9F0C-B7E3942B62EA | 108.90 | 1 | 0.0 | 108.90 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230202164435~D6FB6D1F-F2E2-4DB2-8278-59AAFF09A7F4 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167157 | 2024-12-28 19:58:00 | 75.42 | 0.00 | 0.0 | 75.42 | 0.0 | 0.0 | 241228195800~416C102D-5E2B-47B7-9EA3-4D4D56367D96 | 2024-12-28 | 3087 | 2024-12-28 19:06:33 | 2024-12-28 19:58:00 | dinein | 241228190633~A3D5144B-B4E1-4855-8718-B7995717B526 | 75.42 | 1 | 0.0 | 75.42 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167158 | 2024-12-28 20:38:29 | 99.92 | 0.00 | 0.0 | 99.92 | 0.0 | 0.0 | 241228203829~D10C3768-50E1-4E52-8F0A-F5CBA575A514 | 2024-12-28 | 7419 | 2024-12-28 18:34:50 | 2024-12-28 20:38:29 | dinein | 241228183450~DAE45042-47AA-4DF0-A580-4EB72ACB8763 | 99.92 | 1 | 0.0 | 99.92 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167159 | 2024-12-29 20:32:54 | 82.42 | 0.00 | 0.0 | 82.42 | 0.0 | 0.0 | 241229203254~464AA06D-F986-4C51-8A53-A7B8362072D6 | 2024-12-29 | 4382 | 2024-12-29 19:19:52 | 2024-12-29 20:32:54 | dinein | 241229191952~96F91DE2-5ECC-4AC9-9228-B0741F3494B1 | 82.42 | 1 | 0.0 | 82.42 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 220831171122~1455DBA8-211C-4281-BF27-8698365CA3EB | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167160 | 2024-12-30 20:36:19 | 87.92 | 0.00 | 0.0 | 87.92 | 0.0 | 0.0 | 241230203619~37348A86-98D1-4113-8EDD-06A3CF61A85B | 2024-12-30 | 5244 | 2024-12-30 19:08:55 | 2024-12-30 20:36:19 | dinein | 241230190855~BB4604F2-B7BA-487A-99AF-7AEB77CA3EEC | 87.92 | 1 | 0.0 | 87.92 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167161 | 2024-12-31 14:24:23 | 51.96 | 0.00 | 0.0 | 51.96 | 0.0 | 0.0 | 241231142423~9D2E9295-9E59-4E76-8242-D230C9FD2494 | 2024-12-31 | 963 | 2024-12-31 14:08:20 | 2024-12-31 14:24:23 | takeout | 241231140820~4D531668-3D68-4789-A1DB-BE324D4583D5 | 51.96 | 1 | 0.0 | 51.96 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 161216233231~64B016BA-D9BA-49C7-8726-4BCB6516A11D | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167162 | 2024-12-31 17:00:34 | 49.35 | 11.59 | 0.0 | 49.35 | 0.0 | 0.0 | 241231170034~A9B4401D-26DC-4FC5-A4F9-0261D950DB3B | 2024-12-31 | 59 | 2024-12-31 16:59:35 | 2024-12-31 17:00:34 | takeout | 241231165935~27989697-086C-4F7C-8AB2-8C0A8B2CF3A7 | 49.35 | 1 | 0.0 | 49.35 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6 | FAMILY_DINING | Edmonton | CA | 00:00:00 |
| 167163 | 2024-12-31 18:55:07 | 88.42 | 0.00 | 0.0 | 88.42 | 0.0 | 0.0 | 241231185507~62C6632E-2957-4F0D-8AFF-CF89CA378FB4 | 2024-12-31 | 6556 | 2024-12-31 17:05:51 | 2024-12-31 18:55:07 | dinein | 241231170551~4DEE5611-B193-40FB-858B-0650CE2F7259 | 88.42 | 1 | 0.0 | 88.42 | 45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817 | 230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6 | FAMILY_DINING | Edmonton | CA | 00:00:00 |